<!DOCTYPE html>
<html lang="zh-CN">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Oracle19c静默安装部署 | Yadedoo的文库</title>
    <meta name="generator" content="VuePress 1.9.7">
    <link rel="icon" href="img/favicon.ico">
    <meta name="description" content="Yadedoo的文库, 干货满满!">
    <meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=no">
    
    <link rel="preload" href="/assets/css/0.styles.7c47a738.css" as="style"><link rel="preload" href="/assets/js/app.6ab793bd.js" as="script"><link rel="preload" href="/assets/js/2.c1834578.js" as="script"><link rel="preload" href="/assets/js/12.a8e99ea1.js" as="script"><link rel="prefetch" href="/assets/js/10.551bf274.js"><link rel="prefetch" href="/assets/js/11.540b7b96.js"><link rel="prefetch" href="/assets/js/3.a804e91d.js"><link rel="prefetch" href="/assets/js/4.9585a2a2.js"><link rel="prefetch" href="/assets/js/5.946e4cc7.js"><link rel="prefetch" href="/assets/js/6.7fa5827e.js"><link rel="prefetch" href="/assets/js/7.cea1c6b4.js"><link rel="prefetch" href="/assets/js/8.dbb894b8.js"><link rel="prefetch" href="/assets/js/9.801c7b56.js">
    <link rel="stylesheet" href="/assets/css/0.styles.7c47a738.css">
  </head>
  <body class="theme-mode-light">
    <div id="app" data-server-rendered="true"><div class="theme-container sidebar-open have-rightmenu"><header class="navbar blur"><div title="目录" class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/" class="home-link router-link-active"><!----> <span class="site-name">Yadedoo的文库</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/" class="nav-link">首页</a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="数据平台" class="dropdown-title"><!----> <span class="title" style="display:;">数据平台</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/pages/0ff3bc/" class="nav-link">机器学习</a></li></ul></div></div><div class="nav-item"><a href="/pages/3da17e/" class="nav-link">系统架构</a></div><div class="nav-item"><a href="/pages/3da17e/" class="nav-link">技术开发</a></div><div class="nav-item"><a href="/pages/85e331/" class="nav-link">操作系统</a></div><div class="nav-item"><a href="/pages/aa3ff7/" aria-current="page" class="nav-link router-link-exact-active router-link-active">数据库</a></div><div class="nav-item"><a href="https://baidu.com" target="_blank" rel="noopener noreferrer" class="nav-link external">
  External
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div> <!----></nav></div></header> <div class="sidebar-mask"></div> <div class="sidebar-hover-trigger"></div> <aside class="sidebar" style="display:none;"><!----> <nav class="nav-links"><div class="nav-item"><a href="/" class="nav-link">首页</a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="数据平台" class="dropdown-title"><!----> <span class="title" style="display:;">数据平台</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/pages/0ff3bc/" class="nav-link">机器学习</a></li></ul></div></div><div class="nav-item"><a href="/pages/3da17e/" class="nav-link">系统架构</a></div><div class="nav-item"><a href="/pages/3da17e/" class="nav-link">技术开发</a></div><div class="nav-item"><a href="/pages/85e331/" class="nav-link">操作系统</a></div><div class="nav-item"><a href="/pages/aa3ff7/" aria-current="page" class="nav-link router-link-exact-active router-link-active">数据库</a></div><div class="nav-item"><a href="https://baidu.com" target="_blank" rel="noopener noreferrer" class="nav-link external">
  External
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div> <!----></nav>  <ul class="sidebar-links"><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading open"><span>安装部署</span> <span class="arrow down"></span></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/pages/aa3ff7/" aria-current="page" class="active sidebar-link">Oracle19c静默安装部署</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header level2"><a href="/pages/aa3ff7/#_1、操作系统基础环境" class="sidebar-link">1、操作系统基础环境</a></li><li class="sidebar-sub-header level2"><a href="/pages/aa3ff7/#_2、数据库基础环境" class="sidebar-link">2、数据库基础环境</a></li><li class="sidebar-sub-header level2"><a href="/pages/aa3ff7/#_3、数据库软件安装" class="sidebar-link">3、数据库软件安装</a></li><li class="sidebar-sub-header level2"><a href="/pages/aa3ff7/#_4、数据库实例安装" class="sidebar-link">4、数据库实例安装</a></li></ul></li></ul></section></li></ul> </aside> <div><main class="page"><div class="theme-vdoing-wrapper "><div class="articleInfo-wrap" data-v-0c557b5e><div class="articleInfo" data-v-0c557b5e><ul class="breadcrumbs" data-v-0c557b5e><li data-v-0c557b5e><a href="/" title="首页" class="iconfont icon-home router-link-active" data-v-0c557b5e></a></li> <li data-v-0c557b5e><a href="/categories/?category=%E6%95%B0%E6%8D%AE%E5%BA%93" title="分类" data-v-0c557b5e>数据库</a></li><li data-v-0c557b5e><a href="/categories/?category=%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2" title="分类" data-v-0c557b5e>安装部署</a></li></ul> <div class="info" data-v-0c557b5e><!----> <div title="创建时间" class="date iconfont icon-riqi" data-v-0c557b5e><a href="javascript:;" data-v-0c557b5e>2022-04-01</a></div> <!----></div></div></div> <!----> <div class="content-wrapper"><div class="right-menu-wrapper"><div class="right-menu-margin"><div class="right-menu-title">目录</div> <div class="right-menu-content"></div></div></div> <h1><img src="">Oracle19c静默安装部署<!----></h1> <!----> <div class="theme-vdoing-content content__default"><h1 id="oracle-19c-静默安装"><a href="#oracle-19c-静默安装" class="header-anchor">#</a> Oracle 19C 静默安装</h1> <h2 id="_1、操作系统基础环境"><a href="#_1、操作系统基础环境" class="header-anchor">#</a> 1、操作系统基础环境</h2> <h3 id="_1-1、安装平台"><a href="#_1-1、安装平台" class="header-anchor">#</a> 1.1、安装平台</h3> <p>Linux 7.6</p> <h3 id="_1-2、内核参数"><a href="#_1-2、内核参数" class="header-anchor">#</a> 1.2、内核参数</h3> <h4 id="_1-2-1-修改参数文件"><a href="#_1-2-1-修改参数文件" class="header-anchor">#</a> 1.2.1 修改参数文件</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token function">vi</span> /etc/sysctl.conf 
fs.aio-max-nr <span class="token operator">=</span> <span class="token number">1048576</span>
fs.file-max <span class="token operator">=</span> <span class="token number">6815744</span>
kernel.shmall <span class="token operator">=</span> <span class="token number">16451328</span>       -- 总内存（G）/ <span class="token number">4</span><span class="token punctuation">(</span>页块大小<span class="token punctuation">)</span>* <span class="token number">1024</span> * <span class="token number">1024</span>  单位字节
kernel.shmmax <span class="token operator">=</span> <span class="token number">33692319744</span>    -- <span class="token punctuation">(</span>总内存-4G<span class="token punctuation">)</span> * <span class="token number">1024</span> * <span class="token number">1024</span> * <span class="token number">1024</span>      单位字节
kernel.shmmni <span class="token operator">=</span> <span class="token number">4096</span>
kernel.sem <span class="token operator">=</span> <span class="token number">250</span> <span class="token number">32000</span> <span class="token number">100</span> <span class="token number">128</span>
net.ipv4.ip_local_port_range <span class="token operator">=</span> <span class="token number">9000</span> <span class="token number">65500</span>
net.core.rmem_default <span class="token operator">=</span> <span class="token number">262144</span>
net.core.rmem_max <span class="token operator">=</span> <span class="token number">4194304</span>
net.core.wmem_default <span class="token operator">=</span> <span class="token number">262144</span>
net.core.wmem_max <span class="token operator">=</span> <span class="token number">1048576</span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><h4 id="_1-2-2-立即生效"><a href="#_1-2-2-立即生效" class="header-anchor">#</a> 1.2.2 立即生效</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>/sbin/sysctl -p
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h4 id="_1-2-3、调整用户限制"><a href="#_1-2-3、调整用户限制" class="header-anchor">#</a> 1.2.3、调整用户限制</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token function">vi</span> /etc/security/limits.conf
* hard nofile <span class="token number">65536</span>
* soft nofile <span class="token number">8192</span> 
* hard nproc <span class="token number">65536</span>
* soft nproc <span class="token number">8192</span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br></div></div><h4 id="_1-2-4、配置主机名"><a href="#_1-2-4、配置主机名" class="header-anchor">#</a> 1.2.4、配置主机名</h4> <p>配置主机名和域名的网络映射</p> <h5 id="_1-2-4-1、host文件"><a href="#_1-2-4-1、host文件" class="header-anchor">#</a> 1.2.4.1、host文件</h5> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token function">vi</span> /etc/hosts
<span class="token number">192.168</span>.3.204  bidw01.dongeejiao.com bidw01
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><h5 id="_1-2-4-2、命令修改"><a href="#_1-2-4-2、命令修改" class="header-anchor">#</a> 1.2.4.2、命令修改</h5> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>hostnamectl set-hostname bidw01
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h4 id="_1-2-5、配置环境变量"><a href="#_1-2-5、配置环境变量" class="header-anchor">#</a> 1.2.5、配置环境变量</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token builtin class-name">export</span> <span class="token assign-left variable">NLS_LANG</span><span class="token operator">=</span><span class="token string">&quot;AMERICAN_AMERICA.AL32UTF8&quot;</span>
<span class="token builtin class-name">export</span> <span class="token assign-left variable"><span class="token environment constant">LANG</span></span><span class="token operator">=</span><span class="token string">&quot;en_US.UTF-8&quot;</span>

<span class="token builtin class-name">export</span> <span class="token assign-left variable">ORACLE_BASE</span><span class="token operator">=</span>/home/oratest/app
<span class="token builtin class-name">export</span> <span class="token assign-left variable">ORACLE_HOME</span><span class="token operator">=</span><span class="token variable">$ORACLE_BASE</span>/product/19.3.0
<span class="token builtin class-name">export</span> <span class="token assign-left variable">ORACLE_SID</span><span class="token operator">=</span>ORATEST
<span class="token builtin class-name">export</span> <span class="token assign-left variable"><span class="token environment constant">PATH</span></span><span class="token operator">=</span><span class="token variable">$ORACLE_HOME</span>/bin:<span class="token variable">$ORACLE_HOME</span>/lib:<span class="token variable">$ORACLE_HOME</span>/rdbms/lib:<span class="token environment constant">$PATH</span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><h2 id="_2、数据库基础环境"><a href="#_2、数据库基础环境" class="header-anchor">#</a> 2、数据库基础环境</h2> <h3 id="_2-2、响应文件"><a href="#_2-2、响应文件" class="header-anchor">#</a> 2.2、响应文件</h3> <p>软件：/home/oratest/app/oracle/product/19.5.0/install/response/db_install.rsp<br>
监听：/home/oratest/app/oracle/product/19.5.0/assistants/netca/netca.rsp<br>
建库：/home/oratest/app/oracle/product/19.5.0/assistants/dbca/dbca.rsp</p> <h3 id="_2-3、依赖包"><a href="#_2-3、依赖包" class="header-anchor">#</a> 2.3、依赖包</h3> <p>compat-gcc-44-4.4.7-8.el7.x86_64.rpm<br>
compat-gcc-44-c++-4.4.7-8.el7.x86_64.rpm<br>
compat-libcap1-1.10-7.el7.x86_64.rpm<br>
compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm<br>
cpp-4.8.5-36.el7.x86_64.rpm<br>
elfutils-libelf-0.172-2.el7.x86_64.rpm<br>
elfutils-libelf-devel-0.172-2.el7.x86_64.rpm<br>
gcc-4.8.5-36.el7.x86_64.rpm<br>
gcc-c++-4.8.5-36.el7.x86_64.rpm<br>
glibc-devel-2.17-260.el7.x86_64.rpm<br>
glibc-headers-2.17-260.el7.x86_64.rpm<br>
kernel-headers-3.10.0-957.el7.x86_64.rpm<br>
ksh-20120801-139.el7.x86_64.rpm<br>
libaio-devel-0.3.109-13.el7.x86_64.rpm<br>
libstdc++-4.8.5-36.el7.x86_64.rpm<br>
libstdc++-devel-4.8.5-36.el7.x86_64.rpm<br>
zlib-1.2.7-18.el7.x86_64.rpm<br>
zlib-devel-1.2.7-18.el7.x86_64.rpm</p> <h3 id="_2-4、建立账户"><a href="#_2-4、建立账户" class="header-anchor">#</a> 2.4、建立账户</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token function">groupadd</span> oinstall  
<span class="token function">groupadd</span> dba  
<span class="token function">groupadd</span> asmadmin  
<span class="token function">groupadd</span> asmdba  
<span class="token function">useradd</span> -g oinstall -G dba,asmdba bioracle -d /home/bioracle
<span class="token function">passwd</span> bioracle 
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br></div></div><h2 id="_3、数据库软件安装"><a href="#_3、数据库软件安装" class="header-anchor">#</a> 3、数据库软件安装</h2> <h3 id="_3-1、备份响应文件"><a href="#_3-1、备份响应文件" class="header-anchor">#</a> 3.1、备份响应文件</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token builtin class-name">cd</span> <span class="token variable">$ORACLE_HOME</span>/install/response
<span class="token function">cp</span> db_install.rsp db_install.rsp.bak
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><h3 id="_3-2、配置响应文件"><a href="#_3-2、配置响应文件" class="header-anchor">#</a> 3.2、配置响应文件</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>oracle.install.option<span class="token operator">=</span>INSTALL_DB_SWONLY                 -- 仅安装软件
<span class="token assign-left variable">UNIX_GROUP_NAME</span><span class="token operator">=</span>dba                                     -- 用户组
<span class="token assign-left variable">INVENTORY_LOCATION</span><span class="token operator">=</span>/home/oratest/app/oraInventory       -- 档案路径 
<span class="token assign-left variable">ORACLE_HOME</span><span class="token operator">=</span>/home/oratest/app/oracle/product/19.3.0     -- 主路径
<span class="token assign-left variable">ORACLE_BASE</span><span class="token operator">=</span>/home/oratest/app/oracle                    -- 基路径
oracle.install.db.InstallEdition<span class="token operator">=</span>EE                     -- 企业版
oracle.install.db.OSDBA_GROUP<span class="token operator">=</span>dba                       -- 用户组
oracle.install.db.OSOPER_GROUP<span class="token operator">=</span>dba                      -- 用户组
oracle.install.db.OSBACKUPDBA_GROUP<span class="token operator">=</span>dba                 -- 用户组
oracle.install.db.OSDGDBA_GROUP<span class="token operator">=</span>dba                     -- 用户组
oracle.install.db.OSKMDBA_GROUP<span class="token operator">=</span>dba                     -- 用户组
oracle.install.db.OSRACDBA_GROUP<span class="token operator">=</span>dba                    -- 用户组
oracle.install.db.rootconfig.executeRootScript<span class="token operator">=</span>false    -- 用户组
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h3 id="_3-3、执行安装"><a href="#_3-3、执行安装" class="header-anchor">#</a> 3.3、执行安装</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>./runInstaller -silent -responseFile /home/oratest/app/product/19.3.0/install/response/db_install.rsp
Launching Oracle Database Setup Wizard<span class="token punctuation">..</span>.
The response <span class="token function">file</span> <span class="token keyword">for</span> this session can be found at:
 /home/oratest/app/product/19.3.0/install/response/db_2021-09-08_02-34-55PM.rsp
You can <span class="token function">find</span> the log of this <span class="token function">install</span> session at:
 /tmp/InstallActions2021-09-08_02-34-55PM/installActions2021-09-08_02-34-55PM.log
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br></div></div><h3 id="_3-4、执行root脚本"><a href="#_3-4、执行root脚本" class="header-anchor">#</a> 3.4、执行root脚本</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>As a root user, execute the following script<span class="token punctuation">(</span>s<span class="token punctuation">)</span>:
  <span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span>. /home/oratest/oraInventory/orainstRoot.sh
  <span class="token punctuation">(</span><span class="token number">2</span><span class="token punctuation">)</span>. /home/oratest/app/product/19.3.0/root.sh
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br></div></div><h2 id="_4、数据库实例安装"><a href="#_4、数据库实例安装" class="header-anchor">#</a> 4、数据库实例安装</h2> <h3 id="_4-1、配置监听"><a href="#_4-1、配置监听" class="header-anchor">#</a> 4.1、配置监听</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>netca /silent /responseFile /home/oratest/app/oracle/product/19.3.0/assistants/netca/netca.rsp
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h3 id="_4-2、创建数据库"><a href="#_4-2、创建数据库" class="header-anchor">#</a> 4.2、创建数据库</h3> <h4 id="_4-2-3、备份响应文件"><a href="#_4-2-3、备份响应文件" class="header-anchor">#</a> 4.2.3、备份响应文件</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token builtin class-name">cd</span> /home/oratest/app/product/19.3.0/assistants/dbca
<span class="token function">cp</span> dbca.rsp dbca.rsp.bak
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><h4 id="_4-2-4、编辑响应文件"><a href="#_4-2-4、编辑响应文件" class="header-anchor">#</a> 4.2.4、编辑响应文件</h4> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code><span class="token assign-left variable">gdbName</span><span class="token operator">=</span>ORATEST                                       -- 数据库全局名
<span class="token assign-left variable">sid</span><span class="token operator">=</span>ORATEST                                           -- 数据库SID
<span class="token assign-left variable">databaseConfigType</span><span class="token operator">=</span>SI                                 -- 单实例数据库,SI<span class="token punctuation">\</span>RAC<span class="token punctuation">\</span>RACONENODE
<span class="token assign-left variable">templateName</span><span class="token operator">=</span>General_Purpose.dbc                      -- 通用数据库模板,General_Purpose.dbc<span class="token punctuation">\</span>Data_Warehouse.dbc  
<span class="token assign-left variable">sysPassword</span><span class="token operator">=</span>password                                  -- sys密码
<span class="token assign-left variable">systemPassword</span><span class="token operator">=</span>passowrd                               -- system密码
<span class="token assign-left variable">datafileDestination</span><span class="token operator">=</span>/home/oratest/app/oradata         -- 数据库数据库文件路径
<span class="token assign-left variable">characterSet</span><span class="token operator">=</span>AL32UTF8                                 -- 数据库字符集
<span class="token assign-left variable">createAsContainerDatabase</span><span class="token operator">=</span>true                        -- 是否创建为容器数据库：true<span class="token punctuation">\</span>false
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br></div></div><h3 id="_4-2-5、执行建库脚本"><a href="#_4-2-5、执行建库脚本" class="header-anchor">#</a> 4.2.5、执行建库脚本</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>dbca -silent -createDatabase -responseFile /home/oratest/app/product/19.3.0/assistants/dbca/dbca.rsp
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h3 id="_4-2-6、创建pdb"><a href="#_4-2-6、创建pdb" class="header-anchor">#</a> 4.2.6、创建pdb</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>CREATE PLUGGABLE DATABASE FSSTEST
ADMIN <span class="token environment constant">USER</span> fss_system IDENTIFIED BY <span class="token string">&quot;passwd&quot;</span>
FILE_NAME_CONVERT <span class="token operator">=</span> <span class="token punctuation">(</span><span class="token string">'/home/oratest/app/oradata/ORATEST/pdbseed/'</span>,<span class="token string">'/home/oratest/app/oradata/ORATEST/FSSTEST/'</span><span class="token punctuation">)</span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br></div></div><h3 id="_4-2-7、修改数据库参数"><a href="#_4-2-7、修改数据库参数" class="header-anchor">#</a> 4.2.7、修改数据库参数</h3> <div class="language-bash line-numbers-mode"><pre class="language-bash"><code>alter system <span class="token builtin class-name">set</span> <span class="token assign-left variable">sga_max_size</span><span class="token operator">=</span>24G <span class="token assign-left variable">scope</span><span class="token operator">=</span>spfile<span class="token punctuation">;</span>
alter system <span class="token assign-left variable">setsga_target</span><span class="token operator">=</span>24G <span class="token assign-left variable">scope</span><span class="token operator">=</span>spfile<span class="token punctuation">;</span>
alter system <span class="token assign-left variable">pga_aggregate_limit</span><span class="token operator">=</span>24G<span class="token punctuation">;</span>
alter system <span class="token assign-left variable">pga_aggregate_target</span><span class="token operator">=</span>24G<span class="token punctuation">;</span>
alter system <span class="token assign-left variable">job_queue_processes</span><span class="token operator">=</span><span class="token number">600</span><span class="token punctuation">;</span>
alter system <span class="token assign-left variable">db_writer_processes</span><span class="token operator">=</span><span class="token number">4</span><span class="token punctuation">;</span>
alter system <span class="token assign-left variable">processes</span><span class="token operator">=</span><span class="token number">3000</span> <span class="token assign-left variable">scope</span><span class="token operator">=</span>spfile<span class="token punctuation">;</span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div></div></div> <!----> <div class="page-edit"><!----> <!----> <div class="last-updated"><span class="prefix">上次更新:</span> <span class="time">2022/4/7 11:12:57</span></div></div> <div class="page-nav-wapper"><!----> <!----></div></div> <div class="article-list"><div class="article-title"><a href="/archives/" class="iconfont icon-bi">最近更新</a></div> <div class="article-wrapper"><dl><dd>01</dd> <dt><a href="/pages/0ff3bc/"><div>
            数据基础
            <!----></div></a> <span class="date">04-04</span></dt></dl><dl><dd>02</dd> <dt><a href="/pages/3da17e/"><div>
            Git使用手册
            <!----></div></a> <span class="date">03-31</span></dt></dl><dl><dd>03</dd> <dt><a href="/pages/85e331/"><div>
            Redhat 7 操作系统密码策略
            <!----></div></a> <span class="date">03-31</span></dt></dl> <dl><dd></dd> <dt><a href="/archives/" class="more">更多文章&gt;</a></dt></dl></div></div></main></div> <div class="footer"><!----> 
  Theme by
  <a href="https://github.com/xugaoyi/vuepress-theme-vdoing" target="_blank" title="本站主题">Vdoing</a> <!----></div> <div class="buttons"><div title="返回顶部" class="button blur go-to-top iconfont icon-fanhuidingbu" style="display:none;"></div> <div title="去评论" class="button blur go-to-comment iconfont icon-pinglun" style="display:none;"></div> <div title="主题模式" class="button blur theme-mode-but iconfont icon-zhuti"><ul class="select-box" style="display:none;"><li class="iconfont icon-zidong">
          跟随系统
        </li><li class="iconfont icon-rijianmoshi">
          浅色模式
        </li><li class="iconfont icon-yejianmoshi">
          深色模式
        </li><li class="iconfont icon-yuedu">
          阅读模式
        </li></ul></div></div> <!----> <!----> <!----></div><div class="global-ui"></div></div>
    <script src="/assets/js/app.6ab793bd.js" defer></script><script src="/assets/js/2.c1834578.js" defer></script><script src="/assets/js/12.a8e99ea1.js" defer></script>
  </body>
</html>
